
clear all
set more off
set maxvar 32767
set matsize 11000
global save save


if "`c(username)'"=="marco"  {
global dropbox "/Users/${username}/Dropbox"
global master_file_path "${dropbox}/Engel_GFT/replication_files"
global stataloc "C:\Program Files\Stata17\StataMP-64.exe"
global intermediate "$master_file_path/data/intermediate_data/R43"
global input "$master_file_path/data/source_data/R43"
cd "$input"
}

else if "`c(username)'"=="YOUR NAME"  {
global dropbox "C:/Users/SET USERNAME HERE/Dropbox"
}

**************************************************************
** 1-
** Assemble block 1. household level variables (rural plus urban)
**************************************************************

if 1==1{

        use "$input/block1U.dta",clear
        append using     "$input/block1R.dta"
        $save "$intermediate/hh_list_43.dta", replace
}



*************************************************************
** 2-
** Assemble block 3.(rural plus urban) - religion, soc group, mpce, hhsize
**************************************************************
if 1==1{
        use "$input/block1U.dta",clear
        append using     "$input/block1R.dta"
        $save "$intermediate/block1.dta", replace

    *Replace with hhid permutation from hh43 file:
    gen long hhid= S_No_Village*1000 +SampleHH*10 + SubStratum
    *Note see updated list of hhd in step 3 below (updates this file)
    $save "$intermediate/hh_main_43.dta", replace

    duplicates list hhid

    keep hhid OldPCE HHtypeCode HHreligiousCode HHgroupCode HHsize
    *Note see updated list of hhd in step 3 below (updates this file)
    $save "$intermediate/hh_main_43_skinny.dta", replace
}


**************************************************************
** 3-
** Assemble block 4 -  individual level dataset (rural plus urban)
**************************************************************

if 1==1{

        use "$input/block4R.dta",clear
        append using     "$input/block4U.dta"
        $save "$intermediate/ind_43.dta", replace
		
drop if Srl_number==.

gen long hhid= S_No_Village_Block*1000 +Sample_HH*10 + Sub_Stratum
gen kid=0
replace kid=1 if Age<=16
egen kids=total(kid), by(hhid)
drop kid

gen HH_education_= General_Education_Code if Srl_number==1
egen HH_education=max(HH_education_), by(hhid)

keep if Srl_number==1
keep if Relation_to_Head_Code==1
duplicates list hhid
duplicates tag hhid, gen(x)
drop if x!=0
duplicates list hhid

merge 1:1 hhid using "$intermediate/hh_main_43_skinny.dta"
preserve
keep if _merge==3
drop _merge
keep hhid kids HH_education Age
$save "$intermediate/ind_43_skinny.dta", replace
sum kids


restore
preserve
keep if _merge==3
keep hhid OldPCE HHtypeCode HHreligiousCode HHgroupCode HHsize
sleep 30000
$save "$intermediate/hh_main_43_skinny.dta", replace


restore
drop if _merge==2
drop _merge
keep hhid
merge 1:1 hhid using "$intermediate/hh_main_43.dta"
keep if _merge==3
drop _merge
sleep 30000
save "$intermediate/hh_main_43.dta", replace
}



**************************************************************
** 4-
** Assemble consumption blocks -  (rural plus urban)
**************************************************************


if 1==1{
foreach dataset in "block5_cons_101_479" "block6_cons_480_509" "block6_2_cons_480_509" "block7_cons_510_519" "block7_2_cons_510_519" "block8_cons_520_669" "block9_cons_670_789" "block9_2_cons_670_789" {

        use "$input/`dataset'U.dta",clear
        append using     "$input/`dataset'R.dta"
        tempfile `dataset'
        $save "$intermediate/ind_43.dta", replace

replace Sector=1 if Sector!=2

tempfile `dataset'
$save "$intermediate/`dataset'",replace


}
}



**************************************************************
** 5-
** Make consumption blocks into monthly expenditures (some are 365 days)
**************************************************************

use "$intermediate/block5_cons_101_479.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=QuantityforTotalConsumption/100
gen Flag_quantity_data=1
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=ValueforTotalConsumption/100
label var expenditure "expenditure (30 days)"
gen hhsize= Adultmale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*Multiplier)/1000
gen mpce=MonthlyPCE/100
keep Round- ItemCode mpce hhsize quantity expenditure Flag_quantity_data wt hhid
drop Level
tempfile cons_1
save `cons_1'

*MGN: changed from monthly to annual block:
use "$intermediate/block6_2_cons_480_509.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=(30/365)*(QuantityforTotalConsumption/100)
replace quantity=round(quantity, 0.01)
gen Flag_quantity_data=1
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=(30/365)*(ValueforTotalConsumption/100)
replace expenditure=round(expenditure, 0.01)
label var expenditure "expenditure (30 days)"
gen hhsize= Adultmale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*Multiplier)/1000
gen mpce=MonthlyPCE/100
keep Round- ItemCode mpce hhsize quantity expenditure Flag_quantity_data wt hhid
drop LevelNo
tempfile cons_2
save `cons_2'


use "$intermediate/block7_cons_510_519.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=(30/365)*(QuantityforTotalConsumption/100)
replace quantity=round(quantity, 0.01)
gen Flag_quantity_data=1
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=(30/365)*(ValueforTotalConsumption/100)
replace expenditure=round(expenditure, 0.01)
label var expenditure "expenditure (30 days)"
gen hhsize= Adultmale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*Multiplier)/1000
gen mpce=MonthlyPCE/100
keep Round- ItemCode mpce hhsize quantity expenditure Flag_quantity_data wt hhid
drop Level
tempfile cons_3
save `cons_3', replace

use "$intermediate/block8_cons_520_669.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=.
gen Flag_quantity_data=0
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=CashandKind/100
label var expenditure "expenditure (30 days)"
gen hhsize= Adultmale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*SizeClassofTown)/1000
gen mpce=MonthlyPCE/100
keep Round- ItemCode mpce hhsize quantity expenditure Flag_quantity_data wt hhid
drop Level
tempfile cons_4
save `cons_4'


use "$intermediate/block9_2_cons_670_789.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=.
gen Flag_quantity_data=0
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=(30/365)*(CashandKindfortotalexpenditure/100)
replace expenditure=round(expenditure, 0.01)
label var expenditure "expenditure (30 days)"
gen hhsize= AdultMale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*Multiplier)/1000
keep Round- ItemCode  hhsize quantity expenditure Flag_quantity_data wt hhid
drop Level
tempfile cons_5
save `cons_5'

use "$intermediate/block9_cons_670_789.dta", clear
gen long hhid= SNoVillage*1000 +SampleHH*10 + SubStratum
gen state43=floor(State_Region/10)
gen region43=State_Region-10*floor(State_Region/10)
order state43 region43, before(State_Region)
drop State_Region
gen quantity=.
gen Flag_quantity_data=0
label var Flag_quantity_data "1 if recorded, 0 if not"
label var quantity "quantity (30 days)"
gen expenditure=(30/365)*(CashandKindfortotalexpenditure/100)
replace expenditure=round(expenditure, 0.01)
label var expenditure "expenditure (30 days)"
gen hhsize= AdultMale+ AdultFemale+ ChildMale+ ChildFemale
gen wt=(hhsize*Multiplier)/1000
keep Round- ItemCode  hhsize quantity expenditure Flag_quantity_data wt hhid
drop Level
tempfile cons_6
save `cons_6'


if 1==1{


use `cons_1',clear
forvalues x=2/6 {
append using `cons_`x''
}

egen x=max(mpce), by(hhid)
replace mpce=x if mpce==.
drop x

drop if expenditure==0

if 1==1{
**********************
**labelling
**********************

gen statelabel43=" "
gen grouplabel43=" "
gen regionlabel43=" "
gen itemlabel43=" "

*make states
 replace 	 statelabel43=	"Andhra Pradesh"	 if 	 state43==	2
 replace 	 statelabel43=	"Assam"		 if 	 state43==	3
 replace 	 statelabel43=	"Bihar"	 if 	 state43==	4
 replace 	 statelabel43=	"Gujarat"	 if 	 state43==	5
 replace 	 statelabel43=	"Haryana"	 if 	 state43==	6
 replace 	 statelabel43=	"Himachal Pradesh"	 if 	 state43==	7
 replace 	 statelabel43=	"Jammu & Kashmir"	 if 	 state43==	8
 replace 	 statelabel43=	"Karnataka"	 if 	 state43==	9
 replace 	 statelabel43=	"Kerala"	 if 	 state43==	10
 replace 	 statelabel43=	"Madhya Pradesh"	 if 	 state43==	11
 replace 	 statelabel43=	"Maharashtra"	 if 	 state43==	12
 replace 	 statelabel43=	"Manipur"	 if 	 state43==	13
 replace 	 statelabel43=	"Meghalaya"	 if 	 state43==	14
 replace 	 statelabel43=	"Nagaland"	 if 	 state43==	15
 replace 	 statelabel43=	"Orissa"	 if 	 state43==	16
 replace 	 statelabel43=	"Punjab"	 if 	 state43==	17
 replace 	 statelabel43=	"Rajasthan"	 if 	 state43==	18
 replace 	 statelabel43=	"Sikkim"	 if 	 state43==	19
 replace 	 statelabel43=	"Tamil Nadu"	 if 	 state43==	20
 replace 	 statelabel43=	"Tripura"	 if 	 state43==	21
 replace 	 statelabel43=	"Uttar Pradesh"	 if 	 state43==	22
 replace 	 statelabel43=	"West Bengal"	 if 	 state43==	23
 replace 	 statelabel43=	"Andaman & Nicobar Islands"	 if 	 state43==	24
 replace 	 statelabel43=	"Arunachal Pradesh"	 if 	 state43==	25
 replace 	 statelabel43=	"Chandigarh"	 if 	 state43==	26
 replace 	 statelabel43=	"Dadra & Nagar Haveli"	 if 	 state43==	27
 replace 	 statelabel43=	"Delhi"	 if 	 state43==	28
 replace 	 statelabel43=	"Goa, Daman, & Diu"	 if 	 state43==	29
 replace 	 statelabel43=	"Lakshdweep"	 if 	 state43==	30
 replace 	 statelabel43=	"Mizoram"	 if 	 state43==	31
 replace 	 statelabel43=	"Pondicherry"	 if 	 state43==	32

 *make regions
  replace 	regionlabel43="Coastal" if state43==	2 & region43==	1
 replace 	regionlabel43="Inland Northern" if state43==	2 & region43==	2
 replace 	regionlabel43="South - Western" if state43==	2 & region43==	3
 replace 	regionlabel43="Inland Southern" if state43==	2 & region43==	4

 replace 	regionlabel43="Arunachal Pradesh" if state43==	25 & region43==	1

 replace 	regionlabel43="Plains Eastern" if state43==	3 & region43==	1
 replace 	regionlabel43="Plains Western" if state43==	3 & region43==	2
 replace 	regionlabel43="Hills" if state43==	3 & region43==	3

 replace 	regionlabel43="Southern" if state43==	4 & region43==	1
 replace 	regionlabel43="Northern" if state43==	4 & region43==	2
 replace 	regionlabel43="Central" if state43==	4 & region43==	3

 replace 	regionlabel43="Goa, Daman & Diu" if state43==	29 & region43==	1

 replace 	regionlabel43="Eastern" if state43==	5 & region43==	1
 replace 	regionlabel43="Plains Northern" if state43==	5 & region43==	2
 replace 	regionlabel43="Plains Southern" if state43==	5 & region43==	3
 replace 	regionlabel43="Dry Areas" if state43==	5 & region43==	4
 replace 	regionlabel43="Saurashtra" if state43==	5 & region43==	5

 replace 	regionlabel43="Eastern" if state43==	6 & region43==	1
 replace 	regionlabel43="Western" if state43==	6 & region43==	2

 replace 	regionlabel43="Himachal Pradesh" if state43==	7 & region43==	1

 replace 	regionlabel43="Mountainous" if state43==	8 & region43==	1
 replace 	regionlabel43="Outer Hills" if state43==	8 & region43==	2
 replace 	regionlabel43="Jhelam Valley" if state43==	8 & region43==	3

 replace 	regionlabel43="Coastal & Ghats" if state43==	9 & region43==	1
 replace 	regionlabel43="Island Eastern" if state43==	9 & region43==	2
 replace 	regionlabel43="Island Southern" if state43==	9 & region43==	3
 replace 	regionlabel43="Island Northern" if state43==	9 & region43==	4

 replace 	regionlabel43="Northern" if state43==	10 & region43==	1
 replace 	regionlabel43="Southern" if state43==	10 & region43==	2

 replace 	regionlabel43="Chattisgarh" if state43==	11 & region43==	1
 replace 	regionlabel43="Vindhya" if state43==	11 & region43==	2
 replace 	regionlabel43="Central" if state43==	11 & region43==	3
 replace 	regionlabel43="Malwa Plateau" if state43==	11 & region43==	4
 replace 	regionlabel43="South Central" if state43==	11 & region43==	5
 replace 	regionlabel43="South Western" if state43==	11 & region43==	6
 replace 	regionlabel43="Northern" if state43==	11 & region43==	7

 replace 	regionlabel43="Coastal" if state43==	12 & region43==	1
 replace 	regionlabel43="Inland Western" if state43==	12 & region43==	2
 replace 	regionlabel43="Inland Northern" if state43==	12 & region43==	3
 replace 	regionlabel43="Inland Central" if state43==	12 & region43==	4
 replace 	regionlabel43="Inland Eastern" if state43==	12 & region43==	5
 replace 	regionlabel43="Eastern" if state43==	12 & region43==	6

 replace 	regionlabel43="Plains" if state43==	13 & region43==	1
 replace 	regionlabel43="Hills" if state43==	13 & region43==	2


 replace 	regionlabel43="Meghalaya" if state43==	14 & region43==	1

 replace 	regionlabel43="Mizoram" if state43==	31 & region43==	1

 replace 	regionlabel43="Nagaland" if state43==	15 & region43==	1

 replace 	regionlabel43="Coastal" if state43==	16 & region43==	1
 replace 	regionlabel43="Southern" if state43==	16 & region43==	2
 replace 	regionlabel43="Northern" if state43==	16 & region43==	3

 replace 	regionlabel43="Northern" if state43==	17 & region43==	1
 replace 	regionlabel43="Southern" if state43==	17 & region43==	2

 replace 	regionlabel43="Western" if state43==	18 & region43==	1
 replace 	regionlabel43="North Eastern" if state43==	18 & region43==	2
 replace 	regionlabel43="Southern" if state43==	18 & region43==	3
 replace 	regionlabel43="South Eastern" if state43==	18 & region43==	4

 replace 	regionlabel43="Sikkim" if state43==	19 & region43==	1

 replace 	regionlabel43="Coastal Northern" if state43==	20 & region43==	1
 replace 	regionlabel43="Coastal" if state43==	20 & region43==	2
 replace 	regionlabel43="Southern" if state43==	20 & region43==	3
 replace 	regionlabel43="Inland" if state43==	20 & region43==	4

 replace 	regionlabel43="Tripura" if state43==	21 & region43==	1

 replace 	regionlabel43="Himalayan" if state43==	22 & region43==	1
 replace 	regionlabel43="Western" if state43==	22 & region43==	2
 replace 	regionlabel43="Central" if state43==	22 & region43==	3
 replace 	regionlabel43="Eastern" if state43==	22 & region43==	4
 replace 	regionlabel43="Southern" if state43==	22 & region43==	5

 replace 	regionlabel43="Himalayan" if state43==	23 & region43==	1
 replace 	regionlabel43="Eastern Plains" if state43==	23 & region43==	2
 replace 	regionlabel43="Central Plains" if state43==	23 & region43==	3
 replace 	regionlabel43="Western Plains" if state43==	23 & region43==	4

 replace 	regionlabel43="Andaman & Nicobar Islands" if state43==	24 & region43==	1

 replace 	regionlabel43="Chandigarh" if state43==	26 & region43==	1

 replace 	regionlabel43="Dadra & Nagar Haveli" if state43==	27 & region43==	1

 replace 	regionlabel43="Delhi" if state43==	28 & region43==	1

 replace 	regionlabel43="Lakshadweep" if state43==	30 & region43==	1

 replace 	regionlabel43="Pondicherry" if state43==	32 & region43==	1

 *sectors
rename Sector sector
tostring sector, replace
replace sector="Rural" if sector=="1"
replace sector="Urban" if sector=="2"

 *itemlabels
replace	itemlabel43=	"paddy"	 if 	ItemCode==	101
replace	itemlabel43=	"rice"	 if 	ItemCode==	102
replace	itemlabel43=	"chira"	 if 	ItemCode==	103
replace	itemlabel43=	"khoi, lawa"	 if 	ItemCode==	104
replace	itemlabel43=	"muri"	 if 	ItemCode==	105
replace	itemlabel43=	"other rice products"	 if 	ItemCode==	108
replace	itemlabel43=	"rice :s.t."	 if 	ItemCode==	109
replace	itemlabel43=	"wheat"	 if 	ItemCode==	110
replace	itemlabel43=	"atta"	 if 	ItemCode==	111
replace	itemlabel43=	"maida"	 if 	ItemCode==	112
replace	itemlabel43=	"suji, rawa"	 if 	ItemCode==	113
replace	itemlabel43=	"sewai, noodles"	 if 	ItemCode==	114
replace	itemlabel43=	"bread (bakery)"	 if 	ItemCode==	115
replace	itemlabel43=	"other wheat products"	 if 	ItemCode==	118
replace	itemlabel43=	"wheat :s.t."	 if 	ItemCode==	119
replace	itemlabel43=	"jowar"	 if 	ItemCode==	120
replace	itemlabel43=	"jowar products"	 if 	ItemCode==	121
replace	itemlabel43=	"jowar : s.t."	 if 	ItemCode==	129
replace	itemlabel43=	"bajra"	 if 	ItemCode==	130
replace	itemlabel43=	"bajra products"	 if 	ItemCode==	131
replace	itemlabel43=	"bajra : s.t."	 if 	ItemCode==	139
replace	itemlabel43=	"maize"	 if 	ItemCode==	140
replace	itemlabel43=	"maize products"	 if 	ItemCode==	141
replace	itemlabel43=	"maize : s.t."	 if 	ItemCode==	149
replace	itemlabel43=	"barley"	 if 	ItemCode==	150
replace	itemlabel43=	"barley products"	 if 	ItemCode==	151
replace	itemlabel43=	"barley :s.t."	 if 	ItemCode==	159
replace	itemlabel43=	"small millets"	 if 	ItemCode==	160
replace	itemlabel43=	"small millets products"	 if 	ItemCode==	161
replace	itemlabel43=	"small millets : s.t."	 if 	ItemCode==	169
replace	itemlabel43=	"ragi"	 if 	ItemCode==	170
replace	itemlabel43=	"ragi products"	 if 	ItemCode==	171
replace	itemlabel43=	"ragi :s.t."	 if 	ItemCode==	179
replace	itemlabel43=	"total cereal : (109+119+124+ 139+ 149+159+169+179)"	 if 	ItemCode==	189
replace	itemlabel43=	"gram (full grain)"	 if 	ItemCode==	190
replace	itemlabel43=	"gram products"	 if 	ItemCode==	191
replace	itemlabel43=	"gram : s.t. (190+191)"	 if 	ItemCode==	199
replace	itemlabel43=	"tapioca dry/sago"	 if 	ItemCode==	200
replace	itemlabel43=	"tapioca (green)"	 if 	ItemCode==	201
replace	itemlabel43=	"mahua"	 if 	ItemCode==	202
replace	itemlabel43=	"Jackfruit seed"	 if 	ItemCode==	203
replace	itemlabel43=	"other cereal substitutes"	 if 	ItemCode==	208
replace	itemlabel43=	"cereal substitutes s.t (200-208)"	 if 	ItemCode==	209
replace	itemlabel43=	"arhar(tur)"	 if 	ItemCode==	210
replace	itemlabel43=	"gram (split gram)"	 if 	ItemCode==	211
replace	itemlabel43=	"moong"	 if 	ItemCode==	212
replace	itemlabel43=	"masur"	 if 	ItemCode==	213
replace	itemlabel43=	"urd"	 if 	ItemCode==	214
replace	itemlabel43=	"khasari"	 if 	ItemCode==	215
replace	itemlabel43=	"peas dry"	 if 	ItemCode==	216
replace	itemlabel43=	"soyabean"	 if 	ItemCode==	217
replace	itemlabel43=	"other pulses"	 if 	ItemCode==	218
replace	itemlabel43=	"pulses s.t. (210-218)"	 if 	ItemCode==	219
replace	itemlabel43=	"besan"	 if 	ItemCode==	220
replace	itemlabel43=	"other pulse products"	 if 	ItemCode==	228
replace	itemlabel43=	"pulses and products s.t"	 if 	ItemCode==	229
replace	itemlabel43=	"milk (liquid)"	 if 	ItemCode==	230
replace	itemlabel43=	"baby food"	 if 	ItemCode==	231
replace	itemlabel43=	"milk: condensed/ powder"	 if 	ItemCode==	232
replace	itemlabel43=	"curd"	 if 	ItemCode==	233
replace	itemlabel43=	"ghee"	 if 	ItemCode==	234
replace	itemlabel43=	"butter"	 if 	ItemCode==	235
replace	itemlabel43=	"ice-cream"	 if 	ItemCode==	236
replace	itemlabel43=	"other milk products"	 if 	ItemCode==	238
replace	itemlabel43=	"milk & milk products : s.t."	 if 	ItemCode==	239
replace	itemlabel43=	"vanaspati"	 if 	ItemCode==	240
replace	itemlabel43=	"margarine"	 if 	ItemCode==	241
replace	itemlabel43=	"mustard oil"	 if 	ItemCode==	242
replace	itemlabel43=	"groundnut oil"	 if 	ItemCode==	243
replace	itemlabel43=	"coconut oil"	 if 	ItemCode==	244
replace	itemlabel43=	"gingelly (til) oil"	 if 	ItemCode==	245
replace	itemlabel43=	"linseed oil"	 if 	ItemCode==	246
replace	itemlabel43=	"refined oil"	 if 	ItemCode==	247
replace	itemlabel43=	"palm oil"	 if 	ItemCode==	250
replace	itemlabel43=	"rapeseed oil"	 if 	ItemCode==	251
replace	itemlabel43=	"oil seed"	 if 	ItemCode==	252
replace	itemlabel43=	"edible oil (others)"	 if 	ItemCode==	258
replace	itemlabel43=	"edible oil s.t."	 if 	ItemCode==	259
replace	itemlabel43=	"goat meat"	 if 	ItemCode==	260
replace	itemlabel43=	"mutton"	 if 	ItemCode==	261
replace	itemlabel43=	"beef"	 if 	ItemCode==	262
replace	itemlabel43=	"pork"	 if 	ItemCode==	263
replace	itemlabel43=	"buffalo meat"	 if 	ItemCode==	264
replace	itemlabel43=	"other meat"	 if 	ItemCode==	268
replace	itemlabel43=	"poultry"	 if 	ItemCode==	270
replace	itemlabel43=	"other birds"	 if 	ItemCode==	271
replace	itemlabel43=	"eggs"	 if 	ItemCode==	272
replace	itemlabel43=	"egg products"	 if 	ItemCode==	273
replace	itemlabel43=	"fish (fresh)"	 if 	ItemCode==	274
replace	itemlabel43=	"fish (dry)"	 if 	ItemCode==	275
replace	itemlabel43=	"meat, egg, fish : s.t."	 if 	ItemCode==	279
replace	itemlabel43=	"potato"	 if 	ItemCode==	280
replace	itemlabel43=	"arum"	 if 	ItemCode==	281
replace	itemlabel43=	"radish"	 if 	ItemCode==	282
replace	itemlabel43=	"carrot"	 if 	ItemCode==	283
replace	itemlabel43=	"turnip"	 if 	ItemCode==	284
replace	itemlabel43=	"beet"	 if 	ItemCode==	285
replace	itemlabel43=	"sweet potato"	 if 	ItemCode==	286
replace	itemlabel43=	"onion"	 if 	ItemCode==	287
replace	itemlabel43=	"other root vegetables"	 if 	ItemCode==	288
replace	itemlabel43=	"root vegetable : s.t."	 if 	ItemCode==	289
replace	itemlabel43=	"pumpkin"	 if 	ItemCode==	290
replace	itemlabel43=	"gourd"	 if 	ItemCode==	291
replace	itemlabel43=	"bitter gourd"	 if 	ItemCode==	292
replace	itemlabel43=	"cucumber"	 if 	ItemCode==	293
replace	itemlabel43=	"parwal/patal"	 if 	ItemCode==	294
replace	itemlabel43=	"jhinga/toral"	 if 	ItemCode==	295
replace	itemlabel43=	"snake gourd"	 if 	ItemCode==	296
replace	itemlabel43=	"other gourds"	 if 	ItemCode==	298
replace	itemlabel43=	"gourd : s.t."	 if 	ItemCode==	299
replace	itemlabel43=	"cauliflower"	 if 	ItemCode==	300
replace	itemlabel43=	"cabbage"	 if 	ItemCode==	301
replace	itemlabel43=	"brinjal"	 if 	ItemCode==	302
replace	itemlabel43=	"lady's finger"	 if 	ItemCode==	303
replace	itemlabel43=	"palak"	 if 	ItemCode==	304
replace	itemlabel43=	"other leafy vegetables"	 if 	ItemCode==	305
replace	itemlabel43=	"French beans and barbati"	 if 	ItemCode==	306
replace	itemlabel43=	"Tomato"	 if 	ItemCode==	307
replace	itemlabel43=	"peas fresh"	 if 	ItemCode==	310
replace	itemlabel43=	"chilli (green)"	 if 	ItemCode==	311
replace	itemlabel43=	"capsicum"	 if 	ItemCode==	312
replace	itemlabel43=	"plantain (green)"	 if 	ItemCode==	313
replace	itemlabel43=	"jackfruit (green)"	 if 	ItemCode==	314
replace	itemlabel43=	"lemon (no.)"	 if 	ItemCode==	315
replace	itemlabel43=	"other vegetables"	 if 	ItemCode==	318
replace	itemlabel43=	"other vegetables s.t."	 if 	ItemCode==	319
replace	itemlabel43=	"vegetable (all)"	 if 	ItemCode==	329
replace	itemlabel43=	"banana"	 if 	ItemCode==	330
replace	itemlabel43=	"jackfruit"	 if 	ItemCode==	331
replace	itemlabel43=	"watermelon"	 if 	ItemCode==	332
replace	itemlabel43=	"pineapple"	 if 	ItemCode==	333
replace	itemlabel43=	"coconut"	 if 	ItemCode==	334
replace	itemlabel43=	"guava"	 if 	ItemCode==	335
replace	itemlabel43=	"singara"	 if 	ItemCode==	336
replace	itemlabel43=	"orange, mausami(no.)"	 if 	ItemCode==	337
replace	itemlabel43=	"mango"	 if 	ItemCode==	340
replace	itemlabel43=	"kharbooza"	 if 	ItemCode==	341
replace	itemlabel43=	"pears (naspati)"	 if 	ItemCode==	342
replace	itemlabel43=	"berries"	 if 	ItemCode==	343
replace	itemlabel43=	"leechi"	 if 	ItemCode==	344
replace	itemlabel43=	"apple"	 if 	ItemCode==	345
replace	itemlabel43=	"grapes"	 if 	ItemCode==	346
replace	itemlabel43=	"other fresh fruits"	 if 	ItemCode==	348
replace	itemlabel43=	"fruit (fresh) :s.t."	 if 	ItemCode==	349
replace	itemlabel43=	"coconut (copra)"	 if 	ItemCode==	350
replace	itemlabel43=	"groundnut"	 if 	ItemCode==	351
replace	itemlabel43=	"dates"	 if 	ItemCode==	352
replace	itemlabel43=	"cashew nut"	 if 	ItemCode==	353
replace	itemlabel43=	"walnut"	 if 	ItemCode==	354
replace	itemlabel43=	"other nuts"	 if 	ItemCode==	355
replace	itemlabel43=	"raisin (kishmish, monacca etc.)"	 if 	ItemCode==	356
replace	itemlabel43=	"other dry fruits"	 if 	ItemCode==	358
replace	itemlabel43=	"fruits (dry) : s.t."	 if 	ItemCode==	359
replace	itemlabel43=	"sugar (crystal)"	 if 	ItemCode==	360
replace	itemlabel43=	"Khandsari"	 if 	ItemCode==	361
replace	itemlabel43=	"gur(cane)"	 if 	ItemCode==	362
replace	itemlabel43=	"gur (others)"	 if 	ItemCode==	363
replace	itemlabel43=	"sugar candy (misri)"	 if 	ItemCode==	364
replace	itemlabel43=	"honey"	 if 	ItemCode==	365
replace	itemlabel43=	"sugar (others)"	 if 	ItemCode==	368
replace	itemlabel43=	"sugar :s.t."	 if 	ItemCode==	369
replace	itemlabel43=	"sea salt"	 if 	ItemCode==	370
replace	itemlabel43=	"other salt"	 if 	ItemCode==	371
replace	itemlabel43=	"salt: s.t."	 if 	ItemCode==	379
replace	itemlabel43=	"turmeric"	 if 	ItemCode==	380
replace	itemlabel43=	"black pepper"	 if 	ItemCode==	381
replace	itemlabel43=	"dry chillies"	 if 	ItemCode==	382
replace	itemlabel43=	"garlic"	 if 	ItemCode==	383
replace	itemlabel43=	"tamarind"	 if 	ItemCode==	384
replace	itemlabel43=	"ginger"	 if 	ItemCode==	385
replace	itemlabel43=	"curry powder"	 if 	ItemCode==	386
replace	itemlabel43=	"other spices (gm.)"	 if 	ItemCode==	388
replace	itemlabel43=	"spices : s.t."	 if 	ItemCode==	389
replace	itemlabel43=	"tea (cups)"	 if 	ItemCode==	390
replace	itemlabel43=	"tea (leaf)"	 if 	ItemCode==	391
replace	itemlabel43=	"coffee (cups)"	 if 	ItemCode==	392
replace	itemlabel43=	"coffee (powder)"	 if 	ItemCode==	393
replace	itemlabel43=	"ice"	 if 	ItemCode==	394
replace	itemlabel43=	"Cold beverages: bottled/canned (no.)"	 if 	ItemCode==	395
replace	itemlabel43=	"fruit juice and shake (glass)"	 if 	ItemCode==	396
replace	itemlabel43=	"coconut green (no.)"	 if 	ItemCode==	400
replace	itemlabel43=	"Other beverages: cocoa, chocolate, etc."	 if 	ItemCode==	408
replace	itemlabel43=	"beverages : s.t."	 if 	ItemCode==	409
replace	itemlabel43=	"biscuits"	 if 	ItemCode==	410
replace	itemlabel43=	"salted refreshment"	 if 	ItemCode==	411
replace	itemlabel43=	"prepared sweets"	 if 	ItemCode==	412
replace	itemlabel43=	"cooked meals"	 if 	ItemCode==	413
replace	itemlabel43=	"cake, pastry"	 if 	ItemCode==	414
replace	itemlabel43=	"pickles (gm.)"	 if 	ItemCode==	415
replace	itemlabel43=	"sauce(gm.)"	 if 	ItemCode==	416
replace	itemlabel43=	"jam, jelly (gm.)"	 if 	ItemCode==	417
replace	itemlabel43=	"other processed food"	 if 	ItemCode==	418
replace	itemlabel43=	"processed food :s.t. (410-418)"	 if 	ItemCode==	419
replace	itemlabel43=	"beveragesetc. : s.t. (409+419)"	 if 	ItemCode==	429
replace	itemlabel43=	"pan (leaf)"	 if 	ItemCode==	430
replace	itemlabel43=	"pan (finished)"	 if 	ItemCode==	431
replace	itemlabel43=	"supari"	 if 	ItemCode==	432
replace	itemlabel43=	"lime"	 if 	ItemCode==	433
replace	itemlabel43=	"katha"	 if 	ItemCode==	434
replace	itemlabel43=	"other ingredients for pan"	 if 	ItemCode==	438
replace	itemlabel43=	"pan :s.t. (430-438)"	 if 	ItemCode==	439
replace	itemlabel43=	"bidi"	 if 	ItemCode==	440
replace	itemlabel43=	"cigarettes"	 if 	ItemCode==	441
replace	itemlabel43=	"leaf tobacco"	 if 	ItemCode==	442
replace	itemlabel43=	"snuff (gm)"	 if 	ItemCode==	443
replace	itemlabel43=	"Hookah tobacco (kg.)"	 if 	ItemCode==	444
replace	itemlabel43=	"cheroot (no.)"	 if 	ItemCode==	445
replace	itemlabel43=	"zarda, kimam, surti (gni.)"	 if 	ItemCode==	446
replace	itemlabel43=	"other tobacco products (gm.)"	 if 	ItemCode==	448
replace	itemlabel43=	"tabacco : s.t."	 if 	ItemCode==	449
replace	itemlabel43=	"ganja"	 if 	ItemCode==	450
replace	itemlabel43=	"toddy"	 if 	ItemCode==	451
replace	itemlabel43=	"country liquor"	 if 	ItemCode==	452
replace	itemlabel43=	"opium, bhang, charas (gm.)"	 if 	ItemCode==	453
replace	itemlabel43=	"beer (litre)"	 if 	ItemCode==	454
replace	itemlabel43=	"foreign liquor or refined liquor (brandy, whisky etc.)(litre)"	 if 	ItemCode==	455
replace	itemlabel43=	"other drugs and intoxicants"	 if 	ItemCode==	458
replace	itemlabel43=	"intoxicants : s.t."	 if 	ItemCode==	459
replace	itemlabel43=	"coke"	 if 	ItemCode==	460
replace	itemlabel43=	"firewood and chips"	 if 	ItemCode==	461
replace	itemlabel43=	"electricity"	 if 	ItemCode==	462
replace	itemlabel43=	"dung cake"	 if 	ItemCode==	463
replace	itemlabel43=	"kerosene"	 if 	ItemCode==	464
replace	itemlabel43=	"matches"	 if 	ItemCode==	465
replace	itemlabel43=	"coal"	 if 	ItemCode==	466
replace	itemlabel43=	"coal gas (st. unit)"	 if 	ItemCode==	467
replace	itemlabel43=	"L.P.G. (kg.)"	 if 	ItemCode==	470
replace	itemlabel43=	"charcoal"	 if 	ItemCode==	471
replace	itemlabel43=	"other oil used for lighting (litre.)"	 if 	ItemCode==	472
replace	itemlabel43=	"candle (no.)"	 if 	ItemCode==	473
replace	itemlabel43=	"methylated spirit (litre)"	 if 	ItemCode==	474
replace	itemlabel43=	"gobar gas"	 if 	ItemCode==	475
replace	itemlabel43=	"other fuel and light"	 if 	ItemCode==	478
replace	itemlabel43=	"fuel and light :s.t."	 if 	ItemCode==	479
replace	itemlabel43=	"dhoti"	 if 	ItemCode==	480
replace	itemlabel43=	"saree"	 if 	ItemCode==	481
replace	itemlabel43=	"Cloth for shirt, pyjama, salwar etc. (m)"	 if 	ItemCode==	482
replace	itemlabel43=	"Cloth for coat, trousers, overcoat etc.(m)"	 if 	ItemCode==	483
replace	itemlabel43=	"chaddar, dopatta, wrapper, shawl, etc. (m.)"	 if 	ItemCode==	484
replace	itemlabel43=	"lungi (m.)"	 if 	ItemCode==	485
replace	itemlabel43=	"gamchha, towel, handkerchief etc."	 if 	ItemCode==	486
replace	itemlabel43=	"hosiery articles, stockings, undergarments etc. (no.)"	 if 	ItemCode==	487
replace	itemlabel43=	"ready made garments (no.)"	 if 	ItemCode==	490
replace	itemlabel43=	"headwear (no.)"	 if 	ItemCode==	491
replace	itemlabel43=	"Knitted garments, sweater, pullover, cardigan, muffler, scarf etc. (no.)"	 if 	ItemCode==	492
replace	itemlabel43=	"Bed sheet, bed cover (m.)"	 if 	ItemCode==	493
replace	itemlabel43=	"Rug-blanket (m.)"	 if 	ItemCode==	494
replace	itemlabel43=	"Pillow, quilt, mattress (no.)"	 if 	ItemCode==	495
replace	itemlabel43=	"Cloth for upholstry, curtain, table cloth etc. (m)"	 if 	ItemCode==	496
replace	itemlabel43=	"Mosquito net (no.)"	 if 	ItemCode==	497
replace	itemlabel43=	"Mats and mattings (no.)"	 if 	ItemCode==	500
replace	itemlabel43=	"Cotton, cotton yarn (gm.)"	 if 	ItemCode==	501
replace	itemlabel43=	"Knitting wool (gm.)"	 if 	ItemCode==	502
replace	itemlabel43=	"Clothing - others (no.)"	 if 	ItemCode==	508
replace	itemlabel43=	"clothing :s.t. (480-508)"	 if 	ItemCode==	509
replace	itemlabel43=	"leather boots, shoes"	 if 	ItemCode==	510
replace	itemlabel43=	"leather sandals, chappals, etc."	 if 	ItemCode==	511
replace	itemlabel43=	"Other leather footwear"	 if 	ItemCode==	512
replace	itemlabel43=	"rubber/PVC footwear"	 if 	ItemCode==	513
replace	itemlabel43=	"other footwear"	 if 	ItemCode==	518
replace	itemlabel43=	"footwear (pair) : s.t."	 if 	ItemCode==	519
replace	itemlabel43=	"cinema, theatre"	 if 	ItemCode==	520
replace	itemlabel43=	"mela, fair, picnic"	 if 	ItemCode==	521
replace	itemlabel43=	"sports goods, toys etc."	 if 	ItemCode==	522
replace	itemlabel43=	"club fees"	 if 	ItemCode==	523
replace	itemlabel43=	"goods for recreation and hobbies"	 if 	ItemCode==	524
replace	itemlabel43=	"photography"	 if 	ItemCode==	525
replace	itemlabel43=	"video casette"	 if 	ItemCode==	526
replace	itemlabel43=	"other amusement"	 if 	ItemCode==	528
replace	itemlabel43=	"amusement : s.t. (520-528)"	 if 	ItemCode==	529
replace	itemlabel43=	"books, journals"	 if 	ItemCode==	530
replace	itemlabel43=	"newspapers, periodicals"	 if 	ItemCode==	531
replace	itemlabel43=	"library charges"	 if 	ItemCode==	532
replace	itemlabel43=	"stationary articles"	 if 	ItemCode==	533
replace	itemlabel43=	"tuition fees (school/college)"	 if 	ItemCode==	534
replace	itemlabel43=	"other educational expenses"	 if 	ItemCode==	538
replace	itemlabel43=	"education :s.t. (650-658)"	 if 	ItemCode==	539
replace	itemlabel43=	"allopathic medicine"	 if 	ItemCode==	540
replace	itemlabel43=	"homoeopathic medicine"	 if 	ItemCode==	541
replace	itemlabel43=	"ayurvedic medicine"	 if 	ItemCode==	542
replace	itemlabel43=	"unani medicine"	 if 	ItemCode==	543
replace	itemlabel43=	"family planning appliances"	 if 	ItemCode==	544
replace	itemlabel43=	"other medical expenses"	 if 	ItemCode==	548
replace	itemlabel43=	"medical :s.t. (660-668)"	 if 	ItemCode==	549
replace	itemlabel43=	"spectacles"	 if 	ItemCode==	550
replace	itemlabel43=	"torch light and batteries"	 if 	ItemCode==	551
replace	itemlabel43=	"fountain pen"	 if 	ItemCode==	552
replace	itemlabel43=	"lock"	 if 	ItemCode==	553
replace	itemlabel43=	"umbrella, raincoat"	 if 	ItemCode==	554
replace	itemlabel43=	"walking stick etc."	 if 	ItemCode==	555
replace	itemlabel43=	"lighter (bidi/cigarette/gas stove)"	 if 	ItemCode==	556
replace	itemlabel43=	"other goods for personal care and effects"	 if 	ItemCode==	558
replace	itemlabel43=	"goods for personal care and effect : s.t. (530-538)"	 if 	ItemCode==	559
replace	itemlabel43=	"toilet soap"	 if 	ItemCode==	560
replace	itemlabel43=	"tooth paste, tooth powder, toothbrush"	 if 	ItemCode==	561
replace	itemlabel43=	"powder, snow, cream, flower"	 if 	ItemCode==	562
replace	itemlabel43=	"hair oil, lotion, shampoo, hair cream"	 if 	ItemCode==	563
replace	itemlabel43=	"comb"	 if 	ItemCode==	564
replace	itemlabel43=	"shaving blades"	 if 	ItemCode==	565
replace	itemlabel43=	"shaving stick and shaving cream"	 if 	ItemCode==	566
replace	itemlabel43=	"other shaving requisites"	 if 	ItemCode==	567
replace	itemlabel43=	"other toilet articles"	 if 	ItemCode==	568
replace	itemlabel43=	"toilet articles : s.t. (540-548)"	 if 	ItemCode==	569
replace	itemlabel43=	"electric bulb, tube light"	 if 	ItemCode==	570
replace	itemlabel43=	"electric batteries"	 if 	ItemCode==	571
replace	itemlabel43=	"other non-durable electric goods"	 if 	ItemCode==	572
replace	itemlabel43=	"earthenware"	 if 	ItemCode==	573
replace	itemlabel43=	"glassware"	 if 	ItemCode==	574
replace	itemlabel43=	"plastic goods"	 if 	ItemCode==	575
replace	itemlabel43=	"coir, rope, etc."	 if 	ItemCode==	576
replace	itemlabel43=	"washing soap"	 if 	ItemCode==	577
replace	itemlabel43=	"washing soda"	 if 	ItemCode==	580
replace	itemlabel43=	"other washing requisites"	 if 	ItemCode==	581
replace	itemlabel43=	"agarbati"	 if 	ItemCode==	582
replace	itemlabel43=	"other sundry articles"	 if 	ItemCode==	588
replace	itemlabel43=	"other sundry articles : s.t."	 if 	ItemCode==	589
replace	itemlabel43=	"misc. consumer goods : s.t."	 if 	ItemCode==	599
replace	itemlabel43=	"doctor"	 if 	ItemCode==	600
replace	itemlabel43=	"nurse, midwife"	 if 	ItemCode==	601
replace	itemlabel43=	"hospital charges"	 if 	ItemCode==	602
replace	itemlabel43=	"private tutor"	 if 	ItemCode==	603
replace	itemlabel43=	"domestic servant/cook"	 if 	ItemCode==	604
replace	itemlabel43=	"sweeper"	 if 	ItemCode==	605
replace	itemlabel43=	"barber, beautician etc."	 if 	ItemCode==	606
replace	itemlabel43=	"washerman, launderer"	 if 	ItemCode==	607
replace	itemlabel43=	"tailor"	 if 	ItemCode==	610
replace	itemlabel43=	"priest"	 if 	ItemCode==	611
replace	itemlabel43=	"lawyer"	 if 	ItemCode==	612
replace	itemlabel43=	"postage, telephone, telegram"	 if 	ItemCode==	613
replace	itemlabel43=	"repair charges"	 if 	ItemCode==	614
replace	itemlabel43=	"other consumer services"	 if 	ItemCode==	618
replace	itemlabel43=	"consumer services :s.t.(580-598)"	 if 	ItemCode==	619
replace	itemlabel43=	"railway fare"	 if 	ItemCode==	620
replace	itemlabel43=	"bus fare"	 if 	ItemCode==	621
replace	itemlabel43=	"taxi, auto rickshaw fare"	 if 	ItemCode==	622
replace	itemlabel43=	"bullock cart fare"	 if 	ItemCode==	623
replace	itemlabel43=	"airways fare"	 if 	ItemCode==	624
replace	itemlabel43=	"porter charges"	 if 	ItemCode==	625
replace	itemlabel43=	"steamer, boat fare"	 if 	ItemCode==	626
replace	itemlabel43=	"richshaw (hand drawn and cycle) fare"	 if 	ItemCode==	627
replace	itemlabel43=	"horse cart fare"	 if 	ItemCode==	630
replace	itemlabel43=	"hand operated cart fare"	 if 	ItemCode==	631
replace	itemlabel43=	"petrol"	 if 	ItemCode==	632
replace	itemlabel43=	"diesel"	 if 	ItemCode==	633
replace	itemlabel43=	"lubricating oil"	 if 	ItemCode==	634
replace	itemlabel43=	"other imputed value of owned conveyance"	 if 	ItemCode==	635
replace	itemlabel43=	"school bus/van fare"	 if 	ItemCode==	636
replace	itemlabel43=	"other hired conveyance"	 if 	ItemCode==	638
replace	itemlabel43=	"conveyance : s.t. (600-618)"	 if 	ItemCode==	639
replace	itemlabel43=	"pet, animals, and others (specify)"	 if 	ItemCode==	640
replace	itemlabel43=	"misc. consumer services : s.t."	 if 	ItemCode==	649
replace	itemlabel43=	"house rent, garage rent"	 if 	ItemCode==	650
replace	itemlabel43=	"residential land rent"	 if 	ItemCode==	651
replace	itemlabel43=	"consumer rent (other goods)"	 if 	ItemCode==	652
replace	itemlabel43=	"rent : s.t."	 if 	ItemCode==	659
replace	itemlabel43=	"bedstead"	 if 	ItemCode==	670
replace	itemlabel43=	"almirah"	 if 	ItemCode==	671
replace	itemlabel43=	"dressing table"	 if 	ItemCode==	672
replace	itemlabel43=	"chair"	 if 	ItemCode==	673
replace	itemlabel43=	"coach, sofa"	 if 	ItemCode==	674
replace	itemlabel43=	"table, desk"	 if 	ItemCode==	675
replace	itemlabel43=	"stool, bench"	 if 	ItemCode==	676
replace	itemlabel43=	"suitcase, trunk, box, hand bag and other travel goods"	 if 	ItemCode==	677
replace	itemlabel43=	"foam, rubber cushion (dunlopillo type)"	 if 	ItemCode==	680
replace	itemlabel43=	"carpet, daree, and other floor mattings"	 if 	ItemCode==	681
replace	itemlabel43=	"paintings, drawings, engravings etc."	 if 	ItemCode==	682
replace	itemlabel43=	"other furniture & fixtures"	 if 	ItemCode==	688
replace	itemlabel43=	"furniture & fixtures : s.t."	 if 	ItemCode==	689
replace	itemlabel43=	"gramophone and record player"	 if 	ItemCode==	690
replace	itemlabel43=	"radio"	 if 	ItemCode==	691
replace	itemlabel43=	"radiogram"	 if 	ItemCode==	692
replace	itemlabel43=	"television, video"	 if 	ItemCode==	693
replace	itemlabel43=	"camera and other photographic equipment"	 if 	ItemCode==	694
replace	itemlabel43=	"tape recorder"	 if 	ItemCode==	695
replace	itemlabel43=	"harmonium"	 if 	ItemCode==	696
replace	itemlabel43=	"piano"	 if 	ItemCode==	697
replace	itemlabel43=	"record cassette"	 if 	ItemCode==	700
replace	itemlabel43=	"video cassette"	 if 	ItemCode==	701
replace	itemlabel43=	"other musical instruments"	 if 	ItemCode==	702
replace	itemlabel43=	"other goods for recreation, entertainment and hobbies"	 if 	ItemCode==	708
replace	itemlabel43=	"goods for recreation  s-t."	 if 	ItemCode==	709
replace	itemlabel43=	"gold ornaments"	 if 	ItemCode==	710
replace	itemlabel43=	"silver ornaments"	 if 	ItemCode==	711
replace	itemlabel43=	"jewels, pearls"	 if 	ItemCode==	712
replace	itemlabel43=	"other ornaments"	 if 	ItemCode==	718
replace	itemlabel43=	"jewellery and ornaments : s.t."	 if 	ItemCode==	719
replace	itemlabel43=	"stainless steel"	 if 	ItemCode==	720
replace	itemlabel43=	"bell metal utensils"	 if 	ItemCode==	721
replace	itemlabel43=	"copper utensils"	 if 	ItemCode==	722
replace	itemlabel43=	"aluminium utensils"	 if 	ItemCode==	723
replace	itemlabel43=	"iron utensils"	 if 	ItemCode==	724
replace	itemlabel43=	"brass utensils"	 if 	ItemCode==	725
replace	itemlabel43=	"enamel utensils"	 if 	ItemCode==	726
replace	itemlabel43=	"crockery"	 if 	ItemCode==	727
replace	itemlabel43=	"other household utensils"	 if 	ItemCode==	728
replace	itemlabel43=	"household utensils : s.t"	 if 	ItemCode==	729
replace	itemlabel43=	"electric fan"	 if 	ItemCode==	730
replace	itemlabel43=	"stove (pressure type/wick type)"	 if 	ItemCode==	731
replace	itemlabel43=	"pressure cooker"	 if 	ItemCode==	732
replace	itemlabel43=	"sewing machine"	 if 	ItemCode==	733
replace	itemlabel43=	"washing machine"	 if 	ItemCode==	734
replace	itemlabel43=	"refrigerator"	 if 	ItemCode==	735
replace	itemlabel43=	"air conditioner, air cooler"	 if 	ItemCode==	736
replace	itemlabel43=	"lantern, lamp"	 if 	ItemCode==	737
replace	itemlabel43=	"electric iron, heater, toaster, other electrical heating appliances"	 if 	ItemCode==	740
replace	itemlabel43=	"ovens etc. and other cooking and household appliances/equipments"	 if 	ItemCode==	748
replace	itemlabel43=	"Cooking and household appliances : s.t."	 if 	ItemCode==	749
replace	itemlabel43=	"bicycle"	 if 	ItemCode==	750
replace	itemlabel43=	"motor cycle, scooter"	 if 	ItemCode==	751
replace	itemlabel43=	"motor car, jeep"	 if 	ItemCode==	752
replace	itemlabel43=	"tyres and tubes"	 if 	ItemCode==	753
replace	itemlabel43=	"perambulator"	 if 	ItemCode==	754
replace	itemlabel43=	"other transport equipment"	 if 	ItemCode==	758
replace	itemlabel43=	"personal transport equipment : s.t."	 if 	ItemCode==	759
replace	itemlabel43=	"hearing aids"	 if 	ItemCode==	760
replace	itemlabel43=	"glass eyes, artificial limbs, orthopaedic braces and supports"	 if 	ItemCode==	761
replace	itemlabel43=	"surgical belts, trusses & supports"	 if 	ItemCode==	762
replace	itemlabel43=	"clinical thermometer"	 if 	ItemCode==	763
replace	itemlabel43=	"other therapeutic appliances & equipment"	 if 	ItemCode==	768
replace	itemlabel43=	"Therapeutic appliances & equipment :"	 if 	ItemCode==	769
replace	itemlabel43=	"clock, watch"	 if 	ItemCode==	770
replace	itemlabel43=	"typewriter"	 if 	ItemCode==	771
replace	itemlabel43=	"electric hair drier and shaver"	 if 	ItemCode==	772
replace	itemlabel43=	"any other personal goods"	 if 	ItemCode==	778
replace	itemlabel43=	"other personal goods : s.t."	 if 	ItemCode==	779
replace	itemlabel43=	"residential building and land (cost of repairs only)"	 if 	ItemCode==	780
replace	itemlabel43=	"other durables (specify)"	 if 	ItemCode==	788
replace	itemlabel43=	"durable goods total"	 if 	ItemCode==	789

*group labels
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	101
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	102
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	103
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	104
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	105
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	108
replace	grouplabel43=	"cereals - rice"	 if 	ItemCode==	109

replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	110
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	111
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	112
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	113
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	114
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	115
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	118
replace	grouplabel43=	"cereals - wheat"	 if 	ItemCode==	119

replace	grouplabel43=	"cereals - jowar"	 if 	ItemCode==	120
replace	grouplabel43=	"cereals - jowar"	 if 	ItemCode==	121
replace	grouplabel43=	"cereals - jowar"	 if 	ItemCode==	129

replace	grouplabel43=	"cereals -  bajra"	 if 	ItemCode==	130
replace	grouplabel43=	"cereals -  bajra"	 if 	ItemCode==	131
replace	grouplabel43=	"cereals -  bajra"	 if 	ItemCode==	139

replace	grouplabel43=	"cereals - maize"	 if 	ItemCode==	140
replace	grouplabel43=	"cereals - maize"	 if 	ItemCode==	141
replace	grouplabel43=	"cereals - maize"	 if 	ItemCode==	149

replace	grouplabel43=	"cereals - barley"	 if 	ItemCode==	150
replace	grouplabel43=	"cereals - barley"	 if 	ItemCode==	151
replace	grouplabel43=	"cereals - barley"	 if 	ItemCode==	159

replace	grouplabel43=	"cereals - small millets"	 if 	ItemCode==	160
replace	grouplabel43=	"cereals - small millets"	 if 	ItemCode==	161
replace	grouplabel43=	"cereals - small millets"	 if 	ItemCode==	169
replace	grouplabel43=	"cereals - ragi"	 if 	ItemCode==	170
replace	grouplabel43=	"cereals - ragi"	 if 	ItemCode==	171
replace	grouplabel43=	"cereals - ragi"	 if 	ItemCode==	179
replace	grouplabel43=	"cereals - other"	 if 	ItemCode==	189
replace	grouplabel43=	"gram"	 if 	ItemCode==	190
replace	grouplabel43=	"gram"	 if 	ItemCode==	191
replace	grouplabel43=	"gram"	 if 	ItemCode==	199
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	200
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	201
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	202
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	203
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	208
replace	grouplabel43=	"cereal substitutes"	 if 	ItemCode==	209
replace	grouplabel43=	"pulses"	 if 	ItemCode==	210
replace	grouplabel43=	"pulses"	 if 	ItemCode==	211
replace	grouplabel43=	"pulses"	 if 	ItemCode==	212
replace	grouplabel43=	"pulses"	 if 	ItemCode==	213
replace	grouplabel43=	"pulses"	 if 	ItemCode==	214
replace	grouplabel43=	"pulses"	 if 	ItemCode==	215
replace	grouplabel43=	"pulses"	 if 	ItemCode==	216
replace	grouplabel43=	"pulses"	 if 	ItemCode==	217
replace	grouplabel43=	"pulses"	 if 	ItemCode==	218
replace	grouplabel43=	"pulses"	 if 	ItemCode==	219
replace	grouplabel43=	"pulse products"	 if 	ItemCode==	220
replace	grouplabel43=	"pulse products"	 if 	ItemCode==	228
replace	grouplabel43=	"pulse products"	 if 	ItemCode==	229
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	230
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	231
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	232
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	233
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	234
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	235
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	236
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	238
replace	grouplabel43=	"milk and milk products"	 if 	ItemCode==	239

replace	grouplabel43=	"edible oils"	 if 	ItemCode==	240
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	241
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	242
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	243
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	244
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	245
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	246
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	247
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	250
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	251
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	252
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	258
replace	grouplabel43=	"edible oils"	 if 	ItemCode==	259
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	260
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	261
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	262
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	263
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	264
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	268
replace	grouplabel43=	"meat, egg, fish - red meat"	 if 	ItemCode==	269
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	270
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	271
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	272
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	273
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	274
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	275
replace	grouplabel43=	"meat, egg, fish  - poultry and fish"	 if 	ItemCode==	279
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	280
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	281
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	282
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	283
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	284
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	285
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	286
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	287
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	288
replace	grouplabel43=	"vegetable - root vegetables"	 if 	ItemCode==	289
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	290
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	291
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	292
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	293
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	294
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	295
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	296
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	298
replace	grouplabel43=	"vegetable - gourds"	 if 	ItemCode==	299
replace	grouplabel43=	"leafy vegetables"	 if 	ItemCode==	300
replace	grouplabel43=	"leafy vegetables"	 if 	ItemCode==	301
replace	grouplabel43=	"leafy vegetables"	 if 	ItemCode==	302
replace	grouplabel43=	"leafy vegetables"	 if 	ItemCode==	303
replace	grouplabel43=	"leafy vegetables"	 if 	ItemCode==	304
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	305
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	306
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	307
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	310
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	311
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	312
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	313
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	314
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	315
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	318
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	319
replace	grouplabel43=	"other vegetables"	 if 	ItemCode==	329

replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	330
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	331
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	332
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	333
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	334
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	335
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	336
replace	grouplabel43=	"fresh fruits"	 if 	ItemCode==	337
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	340
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	341
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	342
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	343
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	344
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	345
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	346
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	348
replace	grouplabel43=	"fresh fruits - others"	 if 	ItemCode==	349

replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	350
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	351
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	352
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	353
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	354
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	355
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	356
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	358
replace	grouplabel43=	"dry fruits and nuts"	 if 	ItemCode==	359

replace	grouplabel43=	"sugar"	 if 	ItemCode==	360
replace	grouplabel43=	"sugar"	 if 	ItemCode==	361
replace	grouplabel43=	"sugar"	 if 	ItemCode==	362
replace	grouplabel43=	"sugar"	 if 	ItemCode==	363
replace	grouplabel43=	"sugar"	 if 	ItemCode==	364
replace	grouplabel43=	"sugar"	 if 	ItemCode==	365
replace	grouplabel43=	"sugar"	 if 	ItemCode==	368
replace	grouplabel43=	"sugar"	 if 	ItemCode==	369
replace	grouplabel43=	"salt"	 if 	ItemCode==	370
replace	grouplabel43=	"salt"	 if 	ItemCode==	371
replace	grouplabel43=	"salt"	 if 	ItemCode==	379
replace	grouplabel43=	"spices"	 if 	ItemCode==	380
replace	grouplabel43=	"spices"	 if 	ItemCode==	381
replace	grouplabel43=	"spices"	 if 	ItemCode==	382
replace	grouplabel43=	"spices"	 if 	ItemCode==	383
replace	grouplabel43=	"spices"	 if 	ItemCode==	384
replace	grouplabel43=	"spices"	 if 	ItemCode==	385
replace	grouplabel43=	"spices"	 if 	ItemCode==	386
replace	grouplabel43=	"spices"	 if 	ItemCode==	388
replace	grouplabel43=	"spices"	 if 	ItemCode==	389
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	390
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	391
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	392
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	393
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	394
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	395
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	396
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	400
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	408
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	409
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	410
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	411
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	412
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	413
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	414
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	415
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	416
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	417
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	418
replace	grouplabel43=	"beverages, refreshments and processed food - refreshments and processed food"	 if 	ItemCode==	419
replace	grouplabel43=	"beverages, refreshments and processed food - beverages"	 if 	ItemCode==	429
replace	grouplabel43=	"pan"	 if 	ItemCode==	430
replace	grouplabel43=	"pan"	 if 	ItemCode==	431
replace	grouplabel43=	"pan"	 if 	ItemCode==	432
replace	grouplabel43=	"pan"	 if 	ItemCode==	433
replace	grouplabel43=	"pan"	 if 	ItemCode==	434
replace	grouplabel43=	"pan"	 if 	ItemCode==	438
replace	grouplabel43=	"pan"	 if 	ItemCode==	439
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	440
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	441
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	442
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	443
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	444
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	445
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	446
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	448
replace	grouplabel43=	"tobacco"	 if 	ItemCode==	449
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	450
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	451
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	452
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	453
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	454
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	455
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	458
replace	grouplabel43=	"intoxicants"	 if 	ItemCode==	459
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	460
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	461
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	462
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	463
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	464
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	465
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	466
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	467
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	470
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	471
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	472
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	473
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	474
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	475
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	476
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	477
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	478
replace	grouplabel43=	"fuel and light"	 if 	ItemCode==	479
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	480
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	481
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	482
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	483
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	484
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	485
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	486
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	487
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	490
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	491
replace	grouplabel43=	"clothing - personal wear"	 if 	ItemCode==	492

replace	grouplabel43=	"clothing - linens"	 if 	ItemCode==	493
replace	grouplabel43=	"clothing - linens"	 if 	ItemCode==	494
replace	grouplabel43=	"clothing - linens"	 if 	ItemCode==	495
replace	grouplabel43=	"clothing - linens"	 if 	ItemCode==	496
replace	grouplabel43=	"clothing - linens"	 if 	ItemCode==	497
replace	grouplabel43=	"clothing - other"	 if 	ItemCode==	500
replace	grouplabel43=	"clothing - other"	 if 	ItemCode==	501
replace	grouplabel43=	"clothing - other"	 if 	ItemCode==	502
replace	grouplabel43=	"clothing - other"	 if 	ItemCode==	508
replace	grouplabel43=	"clothing - other"	 if 	ItemCode==	509
replace	grouplabel43=	"footwear"	 if 	ItemCode==	510
replace	grouplabel43=	"footwear"	 if 	ItemCode==	511
replace	grouplabel43=	"footwear"	 if 	ItemCode==	512
replace	grouplabel43=	"footwear"	 if 	ItemCode==	513
replace	grouplabel43=	"footwear"	 if 	ItemCode==	518
replace	grouplabel43=	"footwear"	 if 	ItemCode==	519
replace	grouplabel43=	"amusement"	 if 	ItemCode==	520
replace	grouplabel43=	"amusement"	 if 	ItemCode==	521
replace	grouplabel43=	"amusement"	 if 	ItemCode==	522
replace	grouplabel43=	"amusement"	 if 	ItemCode==	523
replace	grouplabel43=	"amusement"	 if 	ItemCode==	524
replace	grouplabel43=	"amusement"	 if 	ItemCode==	525
replace	grouplabel43=	"amusement"	 if 	ItemCode==	526
replace	grouplabel43=	"amusement"	 if 	ItemCode==	528
replace	grouplabel43=	"amusement"	 if 	ItemCode==	529
replace	grouplabel43=	"education"	 if 	ItemCode==	530
replace	grouplabel43=	"education"	 if 	ItemCode==	531
replace	grouplabel43=	"education"	 if 	ItemCode==	532
replace	grouplabel43=	"education"	 if 	ItemCode==	533
replace	grouplabel43=	"education"	 if 	ItemCode==	534
replace	grouplabel43=	"education"	 if 	ItemCode==	538
replace	grouplabel43=	"education"	 if 	ItemCode==	539
replace	grouplabel43=	"medical"	 if 	ItemCode==	540
replace	grouplabel43=	"medical"	 if 	ItemCode==	541
replace	grouplabel43=	"medical"	 if 	ItemCode==	542
replace	grouplabel43=	"medical"	 if 	ItemCode==	543
replace	grouplabel43=	"medical"	 if 	ItemCode==	544
replace	grouplabel43=	"medical"	 if 	ItemCode==	548
replace	grouplabel43=	"medical"	 if 	ItemCode==	549
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	550
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	551
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	552
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	553
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	554
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	555
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	556
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	558
replace	grouplabel43=	"personal care and effect"	 if 	ItemCode==	559


replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	560
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	561
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	562
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	563
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	564
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	565
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	566
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	567
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	568
replace	grouplabel43=	"toilet articles"	 if 	ItemCode==	569

replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	570
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	571
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	572
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	573
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	574
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	575
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	576
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	577
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	580
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	581
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	582
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	588
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	589
replace	grouplabel43=	"sundry articles"	 if 	ItemCode==	599

replace	grouplabel43=	"consumer services"	 if 	ItemCode==	600
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	601
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	602
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	603
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	604
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	605
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	606
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	607
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	610
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	611
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	612
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	613
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	614
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	618
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	619
replace	grouplabel43=	"miscellaneous consumer services"	 if 	ItemCode==	640
replace	grouplabel43=	"consumer services"	 if 	ItemCode==	649
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	620
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	621
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	622
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	623
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	624
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	625
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	626
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	627
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	630
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	631
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	632
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	633
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	634
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	635
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	636
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	638
replace	grouplabel43=	"conveyance"	 if 	ItemCode==	639
replace	grouplabel43=	"rent"	 if 	ItemCode==	650
replace	grouplabel43=	"rent"	 if 	ItemCode==	651
replace	grouplabel43=	"rent"	 if 	ItemCode==	652
replace	grouplabel43=	"rent"	 if 	ItemCode==	659

replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	670
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	671
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	672
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	673
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	674
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	675
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	676
replace	grouplabel43=	"furniture and fixture -fixture"	 if 	ItemCode==	677
replace	grouplabel43=	"furniture and fixture -fixture"	 if 	ItemCode==	680
replace	grouplabel43=	"furniture and fixture -fixture"	 if 	ItemCode==	681
replace	grouplabel43=	"furniture and fixture -fixture"	 if 	ItemCode==	682
replace	grouplabel43=	"furniture and fixture -fixture"	 if 	ItemCode==	688
replace	grouplabel43=	"furniture and fixture - furniture"	 if 	ItemCode==	689
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	690
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	691
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	692
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	693
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	694
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	695
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	696
replace	grouplabel43=	"Goods recreation, entertainment and hobbies"	 if 	ItemCode==	697
replace	grouplabel43=	"Goods for recreation, entertainment, and hobbies - others"	 if 	ItemCode==	700
replace	grouplabel43=	"Goods for recreation, entertainment, and hobbies - others"	 if 	ItemCode==	701
replace	grouplabel43=	"Goods for recreation, entertainment, and hobbies - others"	 if 	ItemCode==	702
replace	grouplabel43=	"Goods for recreation, entertainment, and hobbies - others"	 if 	ItemCode==	708
replace	grouplabel43=	"Goods for recreation, entertainment, and hobbies - others"	 if 	ItemCode==	709
replace	grouplabel43=	"jewellery and ornaments"	 if 	ItemCode==	710
replace	grouplabel43=	"jewellery and ornaments"	 if 	ItemCode==	711
replace	grouplabel43=	"jewellery and ornaments"	 if 	ItemCode==	712
replace	grouplabel43=	"jewellery and ornaments"	 if 	ItemCode==	718
replace	grouplabel43=	"jewellery and ornaments"	 if 	ItemCode==	719
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	720
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	721
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	722
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	723
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	724
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	725
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	726
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	727
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	728
replace	grouplabel43=	"Household utensils"	 if 	ItemCode==	729
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	730
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	731
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	732
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	733
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	734
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	735
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	736
replace	grouplabel43=	"cooking and household appliances"	 if 	ItemCode==	737
replace	grouplabel43=	"cooking and household appliances - others"	 if 	ItemCode==	740
replace	grouplabel43=	"cooking and household appliances - others"	 if 	ItemCode==	748
replace	grouplabel43=	"cooking and household appliances - others"	 if 	ItemCode==	749
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	750
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	751
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	752
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	753
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	754
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	758
replace	grouplabel43=	"personal transport equipment"	 if 	ItemCode==	759
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	760
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	761
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	762
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	763
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	768
replace	grouplabel43=	"therapeutic appliances and equipments"	 if 	ItemCode==	769
replace	grouplabel43=	"other personal goods"	 if 	ItemCode==	770
replace	grouplabel43=	"other personal goods"	 if 	ItemCode==	771
replace	grouplabel43=	"other personal goods"	 if 	ItemCode==	772
replace	grouplabel43=	"other personal goods"	 if 	ItemCode==	778
replace	grouplabel43=	"other personal goods"	 if 	ItemCode==	779
replace	grouplabel43=	"residential building, land & other durables"	 if 	ItemCode==	780
replace	grouplabel43=	"residential building, land & other durables"	 if 	ItemCode==	788
replace	grouplabel43=	"residential building, land & other durables"	 if 	ItemCode==	789

order state43 statelabel43 regionlabel43 ,before(region43)
order itemlabel43 grouplabel43, after(ItemCode)

}


drop if itemlabel43==" "

*Drop subtotals (Not needed as not in survey).
gen x=mod(ItemCode,10)
drop x

rename ItemCode itemcode43

*Merge in mpce hhsize, wt, caste, religion, from hh_main
merge m:1 hhid using "$intermediate/hh_main_43_skinny.dta"
keep if _merge==3
drop _merge

*Merge in number of kids, education of the head of households
merge m:1 hhid using "$intermediate/ind_43_skinny.dta"
keep if _merge==3
drop _merge

*Create a flag for mpce and sum of exp per capita being very different:
egen sum_exp=total(expenditure), by(hhid)
gen sum_exp_pc=sum_exp/hhsize
gen diff=abs(sum_exp_pc-mpce)
gen flag_mpce=0
replace flag_mpce=1 if diff>=833
label var flag_mpce "mpce more than 833Rs different than sum of exp pc"
drop sum_exp sum_exp_pc diff
merge m:1 hhid using  "$input/District43.dta"
keep if _merge==3
drop _merge
$save "$intermediate/consumption_items_43.dta", replace

}
